home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / tallytypes.sql < prev    next >
Text File  |  2000-05-12  |  720b  |  19 lines
  1. /* RCSVER $Id: tallytypes.sql,v 1.2 2000-02-03 09:40:06-06 randy Exp $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        tallytypes.sql
  6. * Date:        01/27/00
  7. * memo:        Randy Wood
  8. * Description:    Create the tallytypes table. 
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE tallytypes
  12. (
  13.     tgroup    NUMBER(38),        /* Groups tallys accessed by the same key */
  14.     fareset    NUMBER(38),        /* valid fareset */
  15.     ttype      NUMBER(38),        /* ID of this tally type */
  16.     config_num    NUMBER(38),
  17.       CONSTRAINT pk_tallytypes PRIMARY KEY (tgroup, fareset, config_num)
  18. );
  19.